Skip to main content

Supplier Import

Introduction

This will import VISN suppliers for UK and Ireland.

download sample supplier import file.

Fields

Visn Supplier Import

Column PositionHeader NameDescriptionDatatypeValidationMax lengthMandatoryDefault ValueExample
ADI Group IDId of the GroupstringA-Z, 0-9 and all special characters30NoymaA5vcxNWOwzKOdvIMA
BDI Supplier IDId of the SupplierstringA-Z and 0-920NolpEfZekDPAabVoyzcFxM
CERP Garage IDExternal Rate Provider Garage IDNumber0-9-No1900
DERP Garage Group IDExternal Rate Provider Garage Group IDNumber0-9-No768
ELocaleLocale of the supplierstringen_GB(The string should be en_GB for uk supplier) or en_IE(The string should be en_IE for Ireland supplier)-Yesen_GB
FGroup IDGroup ID of the supplierstringA-Z and 0-920YesDIVSN10024
Ghas FNPFNB Availability StatusstringY or N1NoNY
HFNP BandFNP band valueString

Band 1 LA1, Band 2 LA1, Band 3 LA1, Band 5 (M25) LA1, Band 1 LA2, Band 2 LA2, Band 3 LA2, Band 5 (M25) LA2, Band 1 LA3, Band 2 LA3, Band 3 LA3, Band 5 (M25) LA3, NONE

20YesBand 1 LA1
ISupplier Group NameGroup Name of the supplierstringA-Z ,0-9 and all special characters50YesBellinger & Sons Vauxhall Wantage
JSupplier IDId of the supplierstringA-Z ,0-920NoAD13HBG
KSupplier NameName of the supplierstringA-Z ,0-9 and all special characters50NoAncaster Dartford Renault
LPaybill

Determines how the suppliers are paid.

  1. ViSN Hybrid - Customer's Network and DI Network with Paybill.
    VISN - Digital INNK will pay the supplier for this customer
    DIRECT - Customer will pay the supplier directly
  2. ViSN with DI Network and Paybill- Digital INNK will pay the suppliers
  3. External Rate Provider Paybill - External Rate Provider will pay the suppliers

stringVISN or DIRECT-YesVISN
MVAT Registration NumberVAT Registration NumberstringA-Z ,0-920NoVAT1234
NCompany NumberCompany NumberstringA-Z ,0-920NoCMP1234
ONominated Dealer ManagerNominated Dealer ManagerstringA-Z ,0-9, hyphen and space20YesSteve Philips
PAddress 1Building NumberstringA-Z ,0-9 and all special characters20No88
QAddress 2Address 2stringA-Z ,0-9 and all special characters50NoPlaistow Lane
RAddress 3Address 3stringA-Z ,0-9 and all special characters50NoBromley
SAddress 4Address 4stringA-Z ,0-9 and all special characters50NoKent
TAddress 5Address 5stringA-Z ,0-9 and all special characters50NoMiddlesex
UPostcodePostcodestringStandard UK and Ireland postcode validation-YesSE20 7TF
VCustom weekday opening hoursOpening Time (weekday)string24hr time format5No09:00
WCustom Weekday closing hoursClosing Time (weekday)string24hr time format5No17:30
XCustom Sat opening hoursSaturday opening timestring24hr time format5No09:30
YCustom Sat closing hoursSaturday closing timestring24hr time format5No12:30
ZOpen on SundayIs opening on sunday?stringY or N1NoNY
AACustom Sun Opening hoursSunday opening timestring24hr time format5No09:30
ABCustom Sun Closing hoursSunday closing timestring24hr time format5No11:30
ACRegion 1Region 1stringA-Z ,0-9, hyphen and space50NoEvans Halshaw
ADRegion 2Region 2stringA-Z ,0-9, hyphen and space50NoEast Sussex
AERegion 3Region 3stringA-Z ,0-9, hyphen and space50NoBrightonCCC
AFPrimary Phone NumberPrimary Phone NumberstringA-Z ,0-9 and all special characters20Yes02082 908700
AGBooking Phone NumberBooking Phone NumberstringA-Z ,0-9 and all special characters20No02082 908700
AHFax NumberFax NumberstringA-Z ,0-9 and all special characters20No02087 689200
AIemailemail of the supplierstringA-Z ,0-9 and all special characters100Novishwa@digitalinnk.com
AJdescriptiondescriptionstringA-Z ,0-9 and all special characters50Nosupplier from Chelmsford
AKnotesnotesstringA-Z ,0-9 and all special characters20NoNotes
ALMax HeightMax HeightstringA-Z ,0-9,underscore,hyphen and plus sign20No+123
AMMax LengthMax LengthstringA-Z ,0-9,underscore,hyphen and plus sign20No-58
ANMax WeightMax WeightstringA-Z ,0-9,underscore,hyphen and plus sign20No77
AOLast Physical AuditLast Physical Audit-No Validation available for this field-No-
APLast Desktop AuditLast Desktop Audit-No Validation available for this field-No-
AQAncillary equipment servicing & repairsAncillary equipment servicing & repairs (tail lift, flashing beacon, refrigeration units)stringY or N1NoNY
AREngine RebuildEngine RebuildstringY or N1NoNY
ASDPF filtersDPF filtersstringY or N1NoNY
ATLOLER (Weight testing)LOLER (Weight testing)stringY or N1NoNY
AUMis-fuelingMis-fuelingstringY or N1NoNY
AVReplacement keys & door locksReplacement keys & door locksstringY or N1NoNY
AWSmart repairs (to bodywork)Smart repairs (to bodywork)stringY or N1NoNY
AXCollection DelCollection DelstringY or N1NoNY
AYCollection NTDCollection NTDstringY or N1NoNY
AZCollection Lead TimeCollection Lead TimeNumber0-92No44
BACollection RadiusCollection RadiusNumber0-92No22
BBCollection NotesCollection NotesstringA-Z ,0-9 and all special characters30NoCollection Notes
BCCourtesy CarCourtesy CarstringY or N1NoY
BDCourtesy Car NtdCourtesy Car NtdstringY or N1NoNY
BECourtesy Car Lead TimeCourtesy Car Lead TimeNumber0-92No22
BFCourtesy Car NotesCourtesy Car NotesstringA-Z ,0-9 and all special characters30NoNotes about courtesy car service
BGWhile You WaitWhile You WaitstringY or N1NoNY
BHWhile You Wait NTDWhile You Wait NTDstringY or N1NoNY
BIWhile You Wait Lead TimeWhile You Wait Lead TimeNumber0-92No22
BJWhile You Wait NotesWhile You Wait NotesstringA-Z ,0-9 and all special characters30NoNotes about while you wait service
BKDrop OffDrop OffstringY or N1NoNY
BLDrop Off NTDDrop Off NTDstringY or N1NoNY
BMDrop Off Lead TimeDrop Off Lead TimeNumber0-92No43
BNOut Of HoursOut Of HoursstringY or N1NoNY
BOMobileMobilestringY or N1NoNY
BPMobile Lead TimeMobile Off Lead TimeNumber0-92No43
BQMobile RadiusMobile RadiusNumber0-93No43
BRFranchiseFranchisestringA-Z ,0-9 and all special characters30YesAll
BSIndependentIndependentstringY or N1NoNY
BTIs On ViSNIs On ViSNstringY or N1NoNY
BUBosch StatusBosch StatusstringA-Z ,0-98No-
BVNetworkNetworkstringA-Z ,0-98No-
BWNetwork LevelNetwork LevelstringA-Z ,0-98No-
BXLabour CarLabour Carstring0-9 and .(decimal number)6No4.5
BYLabour Rate LCVLabour Rate LCVstring0-9 and .(decimal number)6No4.5
BZLabour Rate EVLabour Rate EVstring0-9 and .(decimal number)6No4.5
CAParts DiscountParts Discountstring0-9 and .(decimal number)5No94.5
CBMOT Class1MOT Class1string0-9, .(three digit decimal number)6No941.5
CCMOT Class2MOT Class2string0-9, .(three digit decimal number)6No941.5
CDMOT Class3MOT Class3string0-9, .(three digit decimal number)6No941.5
CEMOT Class4MOT Class4string0-9, .(three digit decimal number)6No941.5
CFMOT Class5MOT Class5string0-9, .(three digit decimal number)6No941.5
CGMOT Class7MOT Class7string0-9, .(three digit decimal number)6No941.5
CHSemi Synthetic1Semi Synthetic1string0-9 and .(decimal number)6No4.5
CISemi Synthetic2Semi Synthetic2string0-9 and .(decimal number)6No4.5
CJSynthetic1Synthetic1string0-9 and .(decimal number)6No4.5
CKSynthetic2Synthetic2string0-9 and .(decimal number)6No4.5
CLSynthetic3Synthetic3string0-9 and .(decimal number)6No4.5
CMAd BlueAd Bluestring0-9 and .(decimal number)6No4.5
CNBrake FluidBrake Fluidstring0-9 and .(decimal number)6No4.5
COAir Conditioning CoolantAir Conditioning Coolantstring0-9 and .(decimal number)6No4.5
CPAnti FreezeAnti Freezestring0-9 and .(decimal number)6No4.5
CQAutomatic Transmission FluidAutomatic Transmission Fluidstring0-9 and .(decimal number)6No4.5
CRAxle OilAxle Oilstring0-9 and .(decimal number)6No4.5
CSGearbox Oil MineralGearbox Oil Mineralstring0-9 and .(decimal number)6No4.5
CTGearbox Oil SyntheticGearbox Oil Syntheticstring0-9 and .(decimal number)6No4.5
CUHydraulic FluidHydraulic Fluidstring0-9 and .(decimal number)6No4.5
CVLong Life OilLong Life Oilstring0-9 and .(decimal number)6No4.5
CWMineral OilMineral Oilstring0-9 and .(decimal number)6No4.5
CXOther FluidOther Fluidstring0-9 and .(decimal number)6No4.5
CYPower Steering FluidPower Steering Fluidstring0-9 and .(decimal number)6No4.5
CZRefrigerator CoolantRefrigerator Coolantstring0-9 and .(decimal number)6No4.5
DASuspension FluidSuspension Fluidstring0-9 and .(decimal number)6No4.5
DBMerchant FeeMerchant FeestringNo validation present-No-
DCAccount System ReferenceAccount System ReferencestringA-Z,0-98NoABC123
DDService And Maintenance RepairService And Maintenance RepairstringY or N1NoNY
DEAccident Management Body ShopAccident Management Body ShopstringY or N1NoNY
DFTyresTyresstringY or N1NoNY
DGGlassGlassstringY or N1NoNY
DHMOTMOTstringY or N1NoNY
DIBreakdownBreakdownstringY or N1NoNY
DJCarCarstringY or N1NoNY
DKCommercial Under 3_5 tonneCommercial Under 3_5 tonnestringY or N1NoNY
DLCommercial Over 3_5 tonneCommercial Over 3_5 tonnestringY or N1NoNY
DMHGVHGVstringY or N1NoNY
DNMotorBikesMotorBikesstringY or N1NoNY
DOElectric vehicles CarElectric vehicles CarstringY or N1NoNY
DPElectric vehicles LCVElectric vehicles LCVstringY or N1NoNY
DQWash and VacWash and VacstringY or N1NoNY
DRComplimentary RefreshmentsComplimentary RefreshmentsstringY or N1NoNY
DSWiFiWifistringY or N1NoNY
DTParkingParkingstringY or N1NoNY
DUDisposal ChargesDisposal ChargesstringDecimal Number(format should be 00.00)-No99.47
DVValveValvestringDecimal Number(format should be 00.00)-No99.47
DWWheel BalanceWheel BalancestringDecimal Number(format should be 00.00)-No99.47
DXServing ProximityServing Proximitystring

should be a number between '0' and '999' (if serving proximity is not added, then 50 miles will be used as default)

3No955
DYWheel Alignment2Wheel Alignment2stringDecimal Number(format should be 00.00)-No99.47
DZWheel Alignment4Wheel Alignment4stringDecimal Number(format should be 00.00)-No99.47
EARebate AmountRebate AmountstringDecimal Number(format should be 00.00)-No99.47
EBRebate PercentageRebate PercentagestringDecimal Number(format should be 00.00)-No99.47

Importing a file

Preparation

  1. Create a new branch with Jira task number in the branch name

  2. Delete all the files within the importFiles folder to prevent accidental import of incorrect files

  3. Create a folder with the current sprint number

  4. Copy the file that needs to be imported

  5. Go to package.json , find the line validate:suppliers

  6. Modify --leaseId with the required lease Id

  7. Modify --file with the relative path of the file

  8. Modify --leaseCompanyName as per the lease Id

  9. Modify --locale to en_GB or en_IE. Locale will be en_GB by default

  10. Save the package.json

Validating locally

  1. in a terminal run npm run build

  2. in a terminal run npm run validate:suppliers

  3. If there are no errors, push the code

Validating in workflow

  1. Go to Action of Import-manger

  2. Find <Environment> - on-demand-import

  3. Select the branch that was created for this import

  4. Enter script name as validate:suppliers

  5. Leave Overrides empty or you can specify --leaseId, --leaseCompanyName or --locale if required

Importing the file

  1. If the validation has passed

  2. Go to Action of Import-manger

  3. Find <Environment> - on-demand-import

  4. Select the branch that was created for this import

  5. Enter script name as validate:suppliers

  6. Enter --persist in Overrides field

Importing the file via url(using postman and cloud run)

  1. we can also import the file using cloud run. Go to import manager and run action DEV - deploy to cloud run with the latest branch.

  2. Go to cloud run(google cloud console) and select import-manager from the services list.

  3. Copy the url https://import-manager-36r2bu4izq-uc.a.run.app (This might vary for different environments)

  4. Go to postman and paste this url in a post request. Then add the necessary parameters in Body->formData. Please refer image below for parameters to pass.

  5. Upload the file in cloud storage(google cloud console) in the path imports/fileDrop/. Press the upload button to choose the file to import

  1. After uploading run the request using postman. Set the persist parameter to false to validate the file and set it as true to import the file from cloud storage

Testing

  1. Suppliers will be created under the specified group Id. This can be checked in the list of suppliers which belong to the group in DI Admin
Status: Pending Approval
Category: Protected
Authored By: Vignesh Kanthimathinathan on May 31, 2023
Revisions
04 Jan, 2024 - Revise to add FNP band and has FNP, VN-10825
03 Apr, 2025 - Removed a few fields, VN-17231
11 Apr, 2025 - Added specialist services and opening hours, VN-17292 - Hadley